insert overwrite table jms_dim.dim_tab_rou_main_city
select
province
,province_id
,city
,city_id
,area
,area_id
,create_time
,modify_time
,create_by
,create_by_id
,modify_by
,modify_by_id
,id
,is_main
,aging_area_code
,aging_area_desc
,aging_city_code
,aging_city_desc
,is_enable
from jms_ods.tab_rou_main_city where dt = '{{ execution_date | cst_ds }}'
 distribute by 1 ;